=(B17-$I$5)*$F$7-$F$6 =(C17-$I$5)*$F$7-$F$6 =(Q17) =($F$8)+((D17-$I$5)*$F$7)-$F$6 =(S17) "Trailing Stop Loss: Should initially be the same as the ""Initial Stop" "=(IF(C17<$F$10,1,0))" "=(IF(B17>$F$11,1,0))" "=(IF(OR(O17=1,P17=1),""Out"",""In""))" "=(IF(H17<$F$5,""Yes"",""No""))"
=(B18-$I$5)*$F$7-$F$6 =(C18-$I$5)*$F$7-$F$6 =(Q18) =($F$8)+((D18-$I$5)*$F$7)-$F$6 =(S18) " Loss"" and then adjust as the price moves in" "=(IF(C18<$F$10,1,0))" "=(IF(B18>$F$11,1,0))" "=(IF(OR(O18=1,P18=1),""Out"",""In""))" "=(IF(H18<$F$5,""Yes"",""No""))"
=(B19-$I$5)*$F$7-$F$6 =(C19-$I$5)*$F$7-$F$6 =(Q19) =($F$8)+((D19-$I$5)*$F$7)-$F$6 =(S19) price moves in your favor and according to your "=(IF(C19<$F$10,1,0))" "=(IF(B19>$F$11,1,0))" "=(IF(OR(O19=1,P19=1),""Out"",""In""))" "=(IF(H19<$F$5,""Yes"",""No""))"
=(B21-$I$5)*$F$7-$F$6 =(C21-$I$5)*$F$7-$F$6 =(Q21) =($F$8)+((D21-$I$5)*$F$7)-$F$6 =(S21) Target Stop: Use this if you want to liquidate at a specific profit. "=(IF(C21<$F$10,1,0))" "=(IF(B21>$F$11,1,0))" "=(IF(OR(O21=1,P21=1),""Out"",""In""))" "=(IF(H21<$F$5,""Yes"",""No""))"
=(B22-$I$5)*$F$7-$F$6 =(C22-$I$5)*$F$7-$F$6 =(Q22) =($F$8)+((D22-$I$5)*$F$7)-$F$6 =(S22) "Date Bought: Enter nothing, this is referenced to the date you open" "=(IF(C22<$F$10,1,0))" "=(IF(B22>$F$11,1,0))" "=(IF(OR(O22=1,P22=1),""Out"",""In""))" "=(IF(H22<$F$5,""Yes"",""No""))"
=(B24-$I$5)*$F$7-$F$6 =(C24-$I$5)*$F$7-$F$6 =(Q24) =($F$8)+((D24-$I$5)*$F$7)-$F$6 =(S24) Price Bought: Enter the price at which the order was actually executed. "=(IF(C24<$F$10,1,0))" "=(IF(B24>$F$11,1,0))" "=(IF(OR(O24=1,P24=1),""Out"",""In""))" "=(IF(H24<$F$5,""Yes"",""No""))"
=(B25-$I$5)*$F$7-$F$6 =(C25-$I$5)*$F$7-$F$6 =(Q25) =($F$8)+((D25-$I$5)*$F$7)-$F$6 =(S25) Date Liquidated: Enter the date you liquidated the contract. "=(IF(C25<$F$10,1,0))" "=(IF(B25>$F$11,1,0))" "=(IF(OR(O25=1,P25=1),""Out"",""In""))" "=(IF(H25<$F$5,""Yes"",""No""))"
=(B26-$I$5)*$F$7-$F$6 =(C26-$I$5)*$F$7-$F$6 =(Q26) =($F$8)+((D26-$I$5)*$F$7)-$F$6 =(S26) Price Liquidated: Enter the price at which the contract was actually "=(IF(C26<$F$10,1,0))" "=(IF(B26>$F$11,1,0))" "=(IF(OR(O26=1,P26=1),""Out"",""In""))" "=(IF(H26<$F$5,""Yes"",""No""))"
=(B28-$I$5)*$F$7-$F$6 =(C28-$I$5)*$F$7-$F$6 =(Q28) =($F$8)+((D28-$I$5)*$F$7)-$F$6 =(S28) P/L: Enter nothing. The profit/loss is calculated and includes the "=(IF(C28<$F$10,1,0))" "=(IF(B28>$F$11,1,0))" "=(IF(OR(O28=1,P28=1),""Out"",""In""))" "=(IF(H28<$F$5,""Yes"",""No""))"
=(B30-$I$5)*$F$7-$F$6 =(C30-$I$5)*$F$7-$F$6 =(Q30) =($F$8)+((D30-$I$5)*$F$7)-$F$6 =(S30) "Price Data: Paste or enter the Date, High, Low and Close for each" "=(IF(C30<$F$10,1,0))" "=(IF(B30>$F$11,1,0))" "=(IF(OR(O30=1,P30=1),""Out"",""In""))" "=(IF(H30<$F$5,""Yes"",""No""))"
=(B31-$I$5)*$F$7-$F$6 =(C31-$I$5)*$F$7-$F$6 =(Q31) =($F$8)+((D31-$I$5)*$F$7)-$F$6 =(S31) trading session that the position is open. "=(IF(C31<$F$10,1,0))" "=(IF(B31>$F$11,1,0))" "=(IF(OR(O31=1,P31=1),""Out"",""In""))" "=(IF(H31<$F$5,""Yes"",""No""))"
=(B32-$I$5)*$F$7-$F$6 =(C32-$I$5)*$F$7-$F$6 =(Q32) =($F$8)+((D32-$I$5)*$F$7)-$F$6 =(S32) Profit High: Enter nothing. Calculated by subtracting the price at "=(IF(C32<$F$10,1,0))" "=(IF(B32>$F$11,1,0))" "=(IF(OR(O32=1,P32=1),""Out"",""In""))" "=(IF(H32<$F$5,""Yes"",""No""))"
=(B33-$I$5)*$F$7-$F$6 =(C33-$I$5)*$F$7-$F$6 =(Q33) =($F$8)+((D33-$I$5)*$F$7)-$F$6 =(S33) which you bought the contract from the trading session "=(IF(C33<$F$10,1,0))" "=(IF(B33>$F$11,1,0))" "=(IF(OR(O33=1,P33=1),""Out"",""In""))" "=(IF(H33<$F$5,""Yes"",""No""))"
=(B34-$I$5)*$F$7-$F$6 =(C34-$I$5)*$F$7-$F$6 =(Q34) =($F$8)+((D34-$I$5)*$F$7)-$F$6 =(S34) " high, multiplying by the point value and then subtracting" "=(IF(C34<$F$10,1,0))" "=(IF(B34>$F$11,1,0))" "=(IF(OR(O34=1,P34=1),""Out"",""In""))" "=(IF(H34<$F$5,""Yes"",""No""))"
=(B36-$I$5)*$F$7-$F$6 =(C36-$I$5)*$F$7-$F$6 =(Q36) =($F$8)+((D36-$I$5)*$F$7)-$F$6 =(S36) Profit Low: Enter nothing. Calculated by subtracting the price at "=(IF(C36<$F$10,1,0))" "=(IF(B36>$F$11,1,0))" "=(IF(OR(O36=1,P36=1),""Out"",""In""))" "=(IF(H36<$F$5,""Yes"",""No""))"
=(B37-$I$5)*$F$7-$F$6 =(C37-$I$5)*$F$7-$F$6 =(Q37) =($F$8)+((D37-$I$5)*$F$7)-$F$6 =(S37) which you bought the contract from the trading session "=(IF(C37<$F$10,1,0))" "=(IF(B37>$F$11,1,0))" "=(IF(OR(O37=1,P37=1),""Out"",""In""))" "=(IF(H37<$F$5,""Yes"",""No""))"
=(B38-$I$5)*$F$7-$F$6 =(C38-$I$5)*$F$7-$F$6 =(Q38) =($F$8)+((D38-$I$5)*$F$7)-$F$6 =(S38) " low, multipying by the point value and then subtracting" "=(IF(C38<$F$10,1,0))" "=(IF(B38>$F$11,1,0))" "=(IF(OR(O38=1,P38=1),""Out"",""In""))" "=(IF(H38<$F$5,""Yes"",""No""))"
=(B40-$I$5)*$F$7-$F$6 =(C40-$I$5)*$F$7-$F$6 =(Q40) =($F$8)+((D40-$I$5)*$F$7)-$F$6 =(S40) "Stopped Out: Enter nothing. ""Out"" will be printed if the price moves" "=(IF(C40<$F$10,1,0))" "=(IF(B40>$F$11,1,0))" "=(IF(OR(O40=1,P40=1),""Out"",""In""))" "=(IF(H40<$F$5,""Yes"",""No""))"
=(B41-$I$5)*$F$7-$F$6 =(C41-$I$5)*$F$7-$F$6 =(Q41) =($F$8)+((D41-$I$5)*$F$7)-$F$6 =(S41) below your Trailing Stop Loss or below your Target "=(IF(C41<$F$10,1,0))" "=(IF(B41>$F$11,1,0))" "=(IF(OR(O41=1,P41=1),""Out"",""In""))" "=(IF(H41<$F$5,""Yes"",""No""))"
=(B43-$I$5)*$F$7-$F$6 =(C43-$I$5)*$F$7-$F$6 =(Q43) =($F$8)+((D43-$I$5)*$F$7)-$F$6 =(S43) Trading Account (Close): Enter nothing. First the price at which you "=(IF(C43<$F$10,1,0))" "=(IF(B43>$F$11,1,0))" "=(IF(OR(O43=1,P43=1),""Out"",""In""))" "=(IF(H43<$F$5,""Yes"",""No""))"
=(B44-$I$5)*$F$7-$F$6 =(C44-$I$5)*$F$7-$F$6 =(Q44) =($F$8)+((D44-$I$5)*$F$7)-$F$6 =(S44) bought the contract is subtracted from the "=(IF(C44<$F$10,1,0))" "=(IF(B44>$F$11,1,0))" "=(IF(OR(O44=1,P44=1),""Out"",""In""))" "=(IF(H44<$F$5,""Yes"",""No""))"
=(B45-$I$5)*$F$7-$F$6 =(C45-$I$5)*$F$7-$F$6 =(Q45) =($F$8)+((D45-$I$5)*$F$7)-$F$6 =(S45) trading session close and the difference is "=(IF(C45<$F$10,1,0))" "=(IF(B45>$F$11,1,0))" "=(IF(OR(O45=1,P45=1),""Out"",""In""))" "=(IF(H45<$F$5,""Yes"",""No""))"
=(B46-$I$5)*$F$7-$F$6 =(C46-$I$5)*$F$7-$F$6 =(Q46) =($F$8)+((D46-$I$5)*$F$7)-$F$6 =(S46) then multiplied by the point value. That "=(IF(C46<$F$10,1,0))" "=(IF(B46>$F$11,1,0))" "=(IF(OR(O46=1,P46=1),""Out"",""In""))" "=(IF(H46<$F$5,""Yes"",""No""))"
=(B47-$I$5)*$F$7-$F$6 =(C47-$I$5)*$F$7-$F$6 =(Q47) =($F$8)+((D47-$I$5)*$F$7)-$F$6 =(S47) result is then added to the Starting Acct. "=(IF(C47<$F$10,1,0))" "=(IF(B47>$F$11,1,0))" "=(IF(OR(O47=1,P47=1),""Out"",""In""))" "=(IF(H47<$F$5,""Yes"",""No""))"
=(B48-$I$5)*$F$7-$F$6 =(C48-$I$5)*$F$7-$F$6 =(Q48) =($F$8)+((D48-$I$5)*$F$7)-$F$6 =(S48) " Bal. Finally, the commission is subtracted." "=(IF(C48<$F$10,1,0))" "=(IF(B48>$F$11,1,0))" "=(IF(OR(O48=1,P48=1),""Out"",""In""))" "=(IF(H48<$F$5,""Yes"",""No""))"
=(B49-$I$5)*$F$7-$F$6 =(C49-$I$5)*$F$7-$F$6 =(Q49) =($F$8)+((D49-$I$5)*$F$7)-$F$6 =(S49) "Margin Call: Enter nothing. A ""Yes"" will appear if the Trading" "=(IF(C49<$F$10,1,0))" "=(IF(B49>$F$11,1,0))" "=(IF(OR(O49=1,P49=1),""Out"",""In""))" "=(IF(H49<$F$5,""Yes"",""No""))"
=(B51-$I$5)*$F$7-$F$6 =(C51-$I$5)*$F$7-$F$6 =(Q51) =($F$8)+((D51-$I$5)*$F$7)-$F$6 =(S51) Comments: Enter all of your observations including why you "=(IF(C51<$F$10,1,0))" "=(IF(B51>$F$11,1,0))" "=(IF(OR(O51=1,P51=1),""Out"",""In""))" "=(IF(H51<$F$5,""Yes"",""No""))"
=(B52-$I$5)*$F$7-$F$6 =(C52-$I$5)*$F$7-$F$6 =(Q52) =($F$8)+((D52-$I$5)*$F$7)-$F$6 =(S52) change either the Trailing or Target stops. "=(IF(C52<$F$10,1,0))" "=(IF(B52>$F$11,1,0))" "=(IF(OR(O52=1,P52=1),""Out"",""In""))" "=(IF(H52<$F$5,""Yes"",""No""))"
=(B53-$I$5)*$F$7-$F$6 =(C53-$I$5)*$F$7-$F$6 =(Q53) =($F$8)+((D53-$I$5)*$F$7)-$F$6 =(S53) "Final Note: Remember to ""Select"" and ""Print Selection"" because of " "=(IF(C53<$F$10,1,0))" "=(IF(B53>$F$11,1,0))" "=(IF(OR(O53=1,P53=1),""Out"",""In""))" "=(IF(H53<$F$5,""Yes"",""No""))"
=(B54-$I$5)*$F$7-$F$6 =(C54-$I$5)*$F$7-$F$6 =(Q54) =($F$8)+((D54-$I$5)*$F$7)-$F$6 =(S54) " the large table. Table set up for 8.5""x11"" landscape." "=(IF(C54<$F$10,1,0))" "=(IF(B54>$F$11,1,0))" "=(IF(OR(O54=1,P54=1),""Out"",""In""))" "=(IF(H54<$F$5,""Yes"",""No""))"